BREAK LEVEL (level; {page break})
                                                                                    Pg 34-7

level              number      Number of break levels
page break      number     Break level for which to do a page break


Break level specifies on which sort level to cause break processing in a following report. Used in conjunction with  ACCUMULATE to initiate break processing. There are two methods used to turn on break processing for layout reports. Refer to the topic ‘Break Processing’ for information about the two methods.


You must execute BREAK LEVEL and  ACCUMULATE before every layout report for which you want to do break processing. These commands activate break processing for a layout report.

The level is the level to which you want to perform break processing. You must have sorted the records with at least that many levels. If you have sorted more levels, those levels will be printed as sorted, but will not be processed for breaks.

Each break level that is generated will print the corresponding Break areas and Header areas in the layout. There should be level Break areas in the layout. If there are more Break areas, they will be ignored and will not be printed.

The second (optional) argument, page break, is used to cause page breaks during printing.

 
The following example prints a report with two break levels. The selection is sorted on four levels, but the BREAK LEVEL command specifies to break on only two levels. One field is accumulated with the  ACCUMULATE command:

           ` Sort on four levels 
 SORT SELECTION ([People]Dept; >; [People]Title; >; [People]Last; >; [People]First; >) 
           ` Turn on break processing to 2 levels (Dept and Title)
 BREAK LEVEL (2)
 ACCUMULATE ([People]Salary)                   ` Accumulate the salaries
 OUTPUT LAYOUT ([People]; "Dept salary") ` Select the report layout
 PRINT SELECTION([People])                        ` Print the report



See also:  ACCUMULATE, Break Processing